Problems 1-4: You are given the following information for a project:  The initial investment is $750,000 and the cost of capital is 10%.  The project has a six year life and the project’s cash flows are expected to be: Year Total Cash Flow 1 $150,000 2

profileFin-Acc-Boss
 (Not rated)
 (Not rated)
Chat

 

Problems 1-4:                             
You are given the following information for a project:  The initial investment is $750,000 and the cost of capital is 10%.  The project has a six year life and the project’s cash flows are expected to be:      
YearTotal Cash Flow                             
1$150,000                             
2$250,000                             
3$300,000                             
4$400,000                             
5($50,000)    --> negative cash flow                             
6$350,000                             
                               
1.  Determine the payback period. If the payback required by the company is 3 years, what is your recommended decision on this project?               
2Determine the NPV for the project. What is your recommended decision?                      
3.  How much could the firm afford to pay (instead of $750,000) for the project and still decide to go forward (i.e. have an NPV>0)? Assume the cash flows are as shown for years 1-6.          
4. Determine the MIRR for the project. The company requires an MIRR in excess of their cost of capital – what is your decision?               
                               
Problems 5-8:                             
A project that costs $5,000 has expected net cash flows over its 5 year life of:                     
Yr 1$2,500                             
Yr 2$3,500                             
Yr 3$2,000                             
Yr 4$1,500                             
Yr 5$1,000                             
                               
5.  What is the payback period for the project?                          
                               
6.  What is the discounted payback period for the project if the discount rate is 8%?                     
                               
7.  What is the IRR?                             
                               
8.  What is the NPV?                            
                               
                               
Problems 9-11:                             
A project has an upfront cost of $10,000 and a maintenance cost of $7,500 in year 4.  The operating cash flows from the project (not including the maintenance cost in year 4) are:         
Yr 1$3,500                             
Yr 2$5,500                             
Yr 3$6,000                             
Yr 4$4,500                             
Yr 5$4,000                             
Yr 6$4,000                             
                               
9.  Determine the MIRR if the discount rate is 8%.                           
                               
10.  Determine the NPV if the discount rate is 8%.                           
                               
11.  What is the Profitability Index (if the discount rate is 8%)?                        
                               
                             
       
                               
                               
                               
                               
                               
                               
                               
                               
             
                     
  
              
                               
                              
                      
                               
                               
                               
                               
                               
                               
                         
                               
                    
                               
                            
                               
                            
                               
                               
                              
          
                               
                               
                               
                               
                               
                               
                               
                         
                               
                         
                               
                       
                               
                               
    • 9 years ago
    Problems 1-4: You are given the following information for a project: The initial investment is $750,000 and the cost of capital is 10%. The project has a six year life and the project’s cash flows are expected to be: Year Total Cash Flow 1 $150,000 2
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      problems_1_4__final_.xlsx